package com.itheima.dao;

import com.itheima.pojo.Member;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

@Mapper
public interface MemberMapper {
	@Select("select * from t_member where phoneNumber = #{telephone}")
	Member findByTelephone(String telephone);

	@Insert("insert into t_member(fileNumber,name,sex,idCard,phoneNumber,regTime,password,email,birthady,remark) values" +
			"(#{fileNumber}, #{name}, #{sex}, #{idCard}, #{phoneNumber}, #{regTime}, #{password}, #{email}, #{birthday}, #{remark}")
	Integer add(Member member1);
}
